package com.system.user.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.system.user.entity.WaterEntity;
import com.system.user.entityVO.WatchVO;
import com.system.user.entityVO.WaterVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @author HYXK
 * @email null@qq.com
 * @date 2020-03-27 11:55:11
 */
@Mapper
@Repository
public interface WaterDao {

    List<WaterEntity> selectAll();

    List<WaterEntity> selectBySiteOrNumber(WaterEntity waterEntity);

    List<WaterVO> selectByUId(@Param("uId") Integer uId, @Param("number") Integer number);

    List<WaterVO> selectAllByBNumber(@Param("bNumber") String bNumber);

    List<WatchVO> queryWaterByUid(@Param("uid") Integer uid);

    List<WatchVO> queryOtherWatch(WatchVO watchVO);

    WaterEntity selectById(@Param("id") Integer id);

    String selectSiteByNumber(@Param("bNumber") String bNumber);

    int insertWater(WaterEntity waterEntity);

    int updateWater(WaterEntity waterEntity);

    int deleteWater(@Param("id") Integer id);

}
